SQL for Dummies, BA, DA, developers and Job Seekers
What you'll learn
- You will learn how to: install and query on SQL Server
- Importance of E-R modeling and Normalization
- Retrieve, delete, insert and update Data(SELECT INTO, AND, OR , NOT, ORDER BY)
- Clear understanding on different types of keys
- Modifying existing table structure
- AGGREGATE FUNCTIONS (MIN,MAX,SUM,AVG,COUNT)
- Data Conversion(CAST,CONVERT)
- Query using JOINS,UNIONS,DISTINCT,Logical operators
- SQL sub queries (IN, EXISTS, ANY)
- SQL Constraints(NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, INDEX)
- Create VIEW, INDEXES, Triggers, Stored Procedures,cursors, temporary tables, variables, table variables
- Transactions and User-defined Functions
- Interview Questions
Course content
- Preview02:05
- Preview18:58
- 16:56Lecture- 3 Continuing
- 25:53Data Retrieval
- 12:56Advanced Data Manipulation
- 20:23Advanced Data Retrieval
- 14:09Using Indexes, and Views
- 10:39Triggers, Cursors, Transactions and Temporary Table and Table variable
Requirements
- SQL Server - express edition is free
Description
A one stop point for SQL learners and for those applying for SQL developer, BA, DA, DBA jobs. This course will help you crack the interview with hands-on.It has very well explained all the concepts of SQL with examples and also included assignments and interview questions for beginners to practice and for job seekers.
Note This course has not covered advanced level: SSIS, SSRS, Cubes, Replication, Mirroring, Partitioning that are actually required by DBA and Data Analyst. These will be covered in another advanced level SQL course.
Who this course is for:
- This tutorial is ideal for all LEVELS including job seekers for Business Analyst, Data Analyst, Database Administrator, SQL Developers jobs . Course is designed as one stop point for all SQL learners with practical, hands-on, engaging assignments, examples and interview questions.
- It includes 7 lectures of 2-3 hours and another 2-3 hours, student need to complete the assignment. So, Student can learn and prepare for SQL in 8 hours.
Instructor
I have been working in IT industry for over 10 years. I am MCP, MCSD (Microsoft certified solution developer) certified. I have worked for several big organization including Microsoft and during these years, I have been interviewed for new jobs and have also taken interviews to hire Microsoft based technologies experts. So, All my courses are designed to cover ALL LEVELS that a Job Seeker require to crack an interview.