Learn SQL Database Programming with this free online course by Giraffe Academy. Master SQL basics, MySQL installations, data manipulation, queries, and ER diagrams. Perfect for IT beginners.
Course Description
Embark on an enlightening journey with Giraffe Academy's intriguing course, "SQL Database Programming," which promises to elevate your Information Technology skills, delving specifically into the realm of Databases. Spanning a comprehensive 4 hours and 28 minutes, this course is meticulously crafted to transform beginners into adept SQL specialists. Despite not having any reviews yet, it stands as a promising gateway to the fundamentals and advanced nuances of SQL Database Programming.
The course begins with an essential Introduction, setting the stage for the vast array of topics that follow. From understanding the foundational concept of "What is a Database?" to exploring the primary components of SQL, each segment builds upon the previous to ensure a robust learning curve.
Early lessons emphasize the importance of creating a solid base. You'll explore SQL Basics, including detailed guided installations of MySQL on both Windows and Mac platforms. Progressing through, the course dives into the essential elements of database structure by guiding you through Creating Tables and Inserting Data.
Further, the course emphasizes the significance of maintaining data integrity through Constraints and keeping data current with the Update command. You will also find multiple segments dedicated to honing your querying skills, from Basic Queries to more intricate Nested Queries.
One unique aspect of this course is its practical approach to learning through a real-world scenario—the creation and management of a Company Database. This segment covers everything from the introductory concepts to more sophisticated query techniques.
Beyond the basics, the course delves into advanced topics such as Functions, Wildcards, and the usage of Union. You'll also learn about the power of Joins to bring together data from multiple tables, along with the complexity of Nested Queries.
Database management becomes even more comprehensive with lessons on On Delete actions and the implementation of Triggers to automate responses within your database. To further enhance your design skills, the course introduces ER Diagrams, which are essential for visualizing database models. You'll learn to design effective ER diagrams and convert them into schemas, bringing your database design full circle.
While the course may not yet have garnered user reviews, its content and structure are indicative of a thoughtful, in-depth approach to teaching SQL Database Programming. Ideal for anyone looking to break into the IT field or elevate their current skill set, Giraffe Academy’s course ensures you have all the tools needed for success in the modern data-driven world.
Conteúdo do Curso
-
Video class: Introduction | SQL | Tutorial 1
0h02m
-
Exercise: What is a primary purpose of a relational database management system (RDBMS)?
-
Video class: What is a Database? | Let's Learn
0h20m
-
Exercise: What is a database management system (DBMS) and what is its primary purpose?
-
Video class: Tables
0h20m
-
Exercise: In a relational database, which type of key is used to uniquely identify a row within a table and has no direct mapping to real-world data?
-
Video class: SQL Basics | SQL | Tutorial 3
0h09m
-
Exercise: What is one of the primary roles of SQL in a relational database management system?
-
Video class: MySQL Windows Installation | SQL | Tutorial 4
0h09m
-
Exercise: What is the main purpose of a MySQL database server?
-
Video class: MySQL Mac Installation | SQL | Tutorial 5
0h14m
-
Exercise: What is MySQL primarily used for?
-
Video class: Creating Tables - SQL - Tutorial 6
0h15m
-
Exercise: In SQL, which command is used to remove a table from the database?
-
Video class: Inserting Data - SQL - Tutorial 7
0h07m
-
Exercise: What is the SQL command used to add a new row of data into an existing table called?
-
Video class: Constraints - SQL - Tutorial 8
0h10m
-
Exercise: In SQL, which of the following constraints ensures that a column must have a value and that the value must be unique across all rows in the table?
-
Video class: Update
0h08m
-
Exercise: What SQL statement would you use to remove specific rows from a database table based on a condition?
-
Video class: Basic Queries | SQL | Tutorial 10
0h12m
-
Exercise: What would be the result of executing the following SQL command: SELECT name FROM student WHERE major = 'Computer Science' ORDER BY name DESC LIMIT 3?
-
Video class: Company Database Intro | SQL | Tutorial 11
0h08m
-
Exercise: In a given company database schema, an employee table contains an 'employee ID', which is also a primary key. This table also contains two foreign keys: 'super ID' and 'branch ID'. What is the purpose of the 'super ID' foreign key in this schema?
-
Video class: Creating Company Database | SQL | Tutorial 12
0h13m
-
Exercise: Which of the following is true about creating a complex database schema with foreign key relationships?
-
Video class: More Basic Queries | SQL | Tutorial 13
0h06m
-
Exercise: Which SQL statement would retrieve the distinct department names from a table named 'department'?
-
Video class: Functions | SQL | Tutorial 14
0h09m
-
Exercise: Which SQL function would you use to calculate the total expenditure on payroll for all employees in a company?
-
Video class: WIldcards | SQL | Tutorial 15
0h08m
-
Exercise: What would be the appropriate SQL LIKE pattern to find all suppliers whose names contain the word 'Supplies'?
-
Video class: Union | SQL | Tutorial 16
0h08m
-
Exercise: In SQL, which operator can be used to combine the results of multiple SELECT statements into a single result set?
-
Video class: Joins | SQL | Tutorial 17
0h10m
-
Exercise: Which type of SQL join includes all rows from the left table and the matched rows from the right table, filling in with NULL where there is no match?
-
Video class: Nested Queries | SQL | Tutorial 18
0h10m
-
Exercise: What is the primary purpose of using nested queries in SQL?
-
Video class: On Delete | SQL | Tutorial 19
0h08m
-
Exercise: What is a potential consequence of using 'ON DELETE CASCADE' in a foreign key relationship?
This free course includes:
4 hours and 28 minutes of online video course
Exercises to train your knowledge
Certificate of course completion
100% free, from content to certificate