Open

Nested boolean query in elasticsearch

I have an sql query like

select student_name,roll_number 
from
mytable
where
(course = 'CCNA' or course = 'MCSE') and course NOT Like '%network%'

How can i create an equivalent nested boolean query in elasticsearch?