About the Course
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system. You get a big-picture view of using SQL for big data, starting with an overview of data, database systems, then you will learn the characteristics of data analysis using SQL tools for working on big data platforms. You will be taught also how to install an exercise environment (virtual machine) to be used through the course, and you will have practical exploration of databases and tables in that environment during the course of the training.
Salvatech will explain the fundamental concepts in a logical order to build on skills in the best order for you to learn and deeply understand them. Learn a set of fundamental skill sets across data, excel, diagrams, and SQL that will empower you with the skills to be a better data analytics.
What you will Learn
- Learn the essential concepts governing data
- Practice several useful formulas within excel and their data applications
- Learn to read data diagrams
- A wholistic run through of SQL concepts needed to maintain a database
Course Fee: N45,000
Duration: 4 weeks
Delivery Mode – Live, Instructor Led Online
Contact us for Group or Team Registration
Course Outline
SQL WITH MYSQL/POSTGRESQL
● Introduction to SQL
● Installation of RDBMs
● Understanding MySQL Workbench/ Postgres PGAdmin
● Data types
● Constraints in SQL
● Understanding primary key and foreign keys
● Working with SQL command line tools
● Database creation
● Data manipulation language
● Data definition language
● The WHERE clause
● The SELECT keyword
● Updating a table with the UPDATE keyword
● The SQL BETWEEN keyword
● The SQL LIKE keyword
● The SQL IN keyword
● Comments in SQL
● Using MySQL for EXCEL to interact with MySQL
● Importing data into an RDBMSs from external files
● Loading query results into an external file