Database & Query – Let’s Talk SQL (SQL Server, SQLite etc.)

Learn SQL from scratch to a professional with step by step guide from real-life scenario perspective

What you’ll learn

• Use SQL to query database.
• Use SQL to optimize database performance.
• Perform database restore.
• Use SQL to perform data analysis.
• Use SQL for data insight extraction.

Course Content

• Course Introduction –> 7 lectures • 12min.
• Database and Tools –> 4 lectures • 22min.
• Tables and Views –> 5 lectures • 34min.
• Comparison Expressions –> 1 lecture • 8min.
• SQL Statements Fundamentals –> 1 lecture • 19min.
• SQL Aggregate –> 1 lecture • 14min.
• JOINs –> 1 lecture • 16min.
• SQL Server In-Built Function –> 1 lecture • 20min.
• Index –> 3 lectures • 26min.
• DB Programming – Stored Procedure and Functions –> 8 lectures • 1hr 27min.
• Conclusion and Lots More –> 1 lecture • 1min.

Requirements

• Use SQL to create and manage databases
• Create various database objects/entities
• Manipulate with simple and complex queryPerform all various query operations applicable to SQL Server, SQLite, PostgreSQL, MySQL, etc.
• Database and Tools
• Tables and Views (Data Types, Create and alter, Primary Keys, Constraints, Insert, Update, Delete, etc)
• Comparison Expressions (Greater Than, Less Than, Not Equal to, etc)
• SQL Statements Fundamentals (Between, IN, Order By, Select Where, Select Top, etc)
• SQL Aggregate (SUM, Count, Group By, Having, etc)
• JOINS (Inner Join, Left Outer Join, Union, Full Outer Join, etc)
• In-Built Function (IsNumeric, isNULL, Left, Trim, Convert, CAST, etc)
• Index and the importance (Create and Optimize Index)
• Stored Procedure and functions ( SQL Transaction, Exception Handling, Scalar Value Function, Table-Valued Function, Function in Stored Procedure, Stored Procedure in Stored Procedure, Dynamic Query)
• and much, much moreOne of the most in-demand talents, knowing how to read and create sophisticated queries to a database using Microsoft SQL Server, will be taught to you. Any other significant SQL database, including MySQL, PostgreSQL, Amazon Redshift, Oracle, and many more, can be used with these abilities.

  Since SQL is one of the most in-demand tech skills, learning it is one of the fastest methods to improve your professional prospects! You’ll pick up knowledge fast in this course, and along the way, you’ll face obstacles and assessments to sharpen your comprehension! You will acquire all the skills required to become a SQL Pro in this course!

   

  The course runs at a steady pace for any learner to easily understand and practice alongside.