About the Course
Learn SQL to manage your database records which includes creating tables, defining relationships, executing queries to retrieve and manipulate data, and more.
Topics CoveredA beginner’s training program to learn from scratch the basics of SQL or database programming. Once you complete this course you will be well versed with most important and most significant SQL commands, learn to execute queries, execute transactions, create stored procedures, etc.
Inserting data to tables
Importing data to tables
Retrieving data using SELECT statement
Filtering and removing duplicates
Modifying data using UPDATE statement
Working with numbers, strings and date
Altering table schema using ALTER statement
Deleting data using DELETE statement
SQL functions – built-in and user defined
Using Stored procedures
Using Views, Triggers and indexes
Who should attendAnyone interested to learn about SQL programming and database concepts
What you need to bringNA
Key TakeawaysAfter the training you will be proficient in designing database, SQL programming and optimization.