Course Description
This SQL tutorial series covers all the fundamental concepts of SQL language, such as creating database and tables, using constraints, adding records to a table, selecting records from a table based on different conditions, updating and deleting records in a table, and so on.Once you’re familiar with the basics, you’ll move on to next level that explains the methods of retrieving records through joining multiple tables, searching records in the table based on pattern, etc.Finally, you’ll explore some advanced concepts, such as modifying the existing table structure, performing aggregations and grouping data together, creating views to simplify and secure table access, creating indexes for tables, handling dates and times, cloning of an existing table, creating temporary tables, as well as, concept of SQL subqueries and SQL injection.Our SQL Course will help you to learn the fundamentals of the SQL language, from the basic to advanced topics step-by-step. If you’re a beginner, start with the basic section and gradually move forward by learning a little bit every day.
Aim & Objective
Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.Course Lessons ( Modules)
Introduction to SQL
-
What is SQL?
00:00 -
What can SQL do?
00:00 -
Using SQL Web
00:00 -
Basic SQL syntax
00:00 -
Data types
00:00 -
Tables and columns
00:00 -
Primary keys and foreign keys
00:00 -
Creating and modifying table
00:00 -
Inserting, updating, and deleting data
00:00 -
Selecting data from tables
00:00
Advanced SQL
-
Subqueries
00:00 -
Joins
00:00 -
Aggregations
00:00 -
Window functions
00:00 -
Common Table Expressions (CTEs)
00:00 -
Triggers and stored procedures
00:00
SQL Programming
-
Using SQL in programming languages
00:00 -
Handling errors and exceptions
00:00 -
Performance tuning
00:00 -
Security and authorization
00:00 -
Data warehousing and business intelligence
00:00
SQL Projects
-
Developing a database schema
00:00 -
Creating and populating tables
00:00 -
Writing SQL queries to retrieve and manipulate data
00:00 -
Designing and implementing a database application
00:00
SQL Certification
-
Preparing for SQL certification exams
00:00 -
Review of SQL concepts and syntax
00:00 -
Practice exams and simulations
00:00
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
3 months ago
Trust me when I say I am now a database administrator. Thanks to Edu Plus Network