Description
Détails
Formateur
Description
The Complete SQL Bootcamp teaches you SQL from the basics to a professional level. This course will teach you about databases and SQL. It will teach developers how to write SQL queries, manipulate data and create database objects.
This SQL course is designed to improve your SQL skills. Led by an experienced instructor, this course offers a well-organised and engaging learning experience for those who want to master SQL.
Learning Objectives:
By the end of the course, you will learn how to:
- Retrieve Data using basic SQL SELECT Statements
- Restrict and Sort Data
- Use Aggregate Functions
- Apply Conditional Expressions
- Generate Reports with Aggregated Data Using Group Functions
- Display Data from Multiple Tables Using Joins
- Utilize Window Functions
- Work with Common Table Expressions (CTEs) using the WITH clause
- Manage Data using Subqueries and Advanced Queries
- Manage Tables using DML Statements
- Create Sequences, Views, and Schema Objects
Who is this course for?
This course is designed for learners at all levels, from beginners looking for a solid foundation to SQL professionals striving for mastery. No prior knowledge is necessary. It is suitable for users of any database, including Oracle, MySQL, Microsoft SQL Server, Amazon Redshift, and PostgreSQL.
Détails
- 27 Sections
- 215 Lessons
- 3 Hours
Expand all sectionsCollapse all sections
- ---Day11
- Data Definition n(Users, Roles) and Privileges13
- 1.0CREATE USER
- 1.1CREATE ROLE
- 1.2Data Control Language (DCL)
- 1.3GRANT specific privileges to a role
- 1.4GRANT ALL PRIVILEGES to a role
- 1.5GRANT specific privileges to a user
- 1.6GRANT(add members on the existing role)
- 1.7REVOKE specific privileges from a role
- 1.8REVOKE ALL PRIVILEGES from a role
- 1.9REVOKE (remove members on the existing role)
- 1.10DROP USERS
- 1.11DROP ROLES
- 1.12Data Definition(Users, Roles) and Privileges10 Minutes0 Questions
- Introduction7
- Basic Select Statement15
- 3.0Basic Select Statement
- 3.1Literal (character, String)
- 3.2Literal (constant)
- 3.3Non-numeric Literals
- 3.4Numeric Literals
- 3.5Literal
- 3.6Arithmetic Expression Operators
- 3.7Mathematical Operator Precedence
- 3.8Mathematical Operator Precedence
- 3.9Using aliases
- 3.10Using aliases
- 3.11Escape character sequence
- 3.12Concatenation Operator
- 3.13Comments Within SQL Statements code
- 3.14Basic Select Statement
- Data Types7
- Selecting from a table10
- 5.0SELECTING columns or expressions FROM a table
- 5.1Selecting All Columns
- 5.2SELECT all columns3 Days
- 5.3Selecting Specific Columns or Expressions
- 5.4SELECT specific columns3 Days
- 5.5Using Column Aliases3 Days
- 5.6Eliminating duplicate rows
- 5.7Eliminating duplicate rows3 Days
- 5.8SELECT from a generated (VALUES Lists)
- 5.9Selecting from a table3 Days
- WHERE clause and ORDER BY clause19
- 7.0Using WHERE Clause
- 7.1Using WHERE Clause3 Days
- 7.2Comparison Operators
- 7.3Match any Range search condition( [NOT] BETWEEN )
- 7.4Match any Range search condition( [NOT] BETWEEN)3 Days
- 7.5Match any of a list of values ( [NOT] IN )
- 7.6Pattern match search condition ( [NOT] LIKE )
- 7.7Using ( IS [NOT] NULL ) Conditions
- 7.8Using the AND Operator
- 7.9Using the OR Operator
- 7.10Rules of Precedence(Order of operation )
- 7.11ORDER BY clause
- 7.12OFFSET
- 7.13FETCH
- 7.14LIMIT
- 7.15LIMIT3 Days
- 7.16OFFSET and FETCH
- 7.17OFFSET and LIMIT
- 7.18WHERE clause and ORDER BY clause
- ---Day21
- Functions and Operators16
- 9.0Functions and Operators
- 9.1String functions and Operators (String Concatenation)
- 9.2String functions(Case Conversion)
- 9.3Show part of a string(LEFT,RIGHT, SUBSTR)
- 9.4Show part of a string(SUBSTR)3 Days
- 9.5Remove from a String(TRIM,LTRIM,RTRIM)
- 9.6Add and Replace characters in a String(LPAD, RPAD, REPLACE)
- 9.7Length of string(LENGTH)
- 9.8Using MODULUS Function
- 9.9Using MODULUS Function3 Days
- 9.10Using CEILING and FLOOR Function
- 9.11Using CEILING and FLOOR Function3 Days
- 9.12Using ROUND and TRUNCATE Function
- 9.13(Date , Time Functions)
- 9.14(Date , Time Functions)3 Days
- 9.15Functions and Operators
- Regular Expression19
- 10.0Introduction
- 10.1POSIX Regular Expressions
- 10.2Regular Expressions Atoms
- 10.3Literal Characters:
- 10.4Dot : .
- 10.5Regular Expression Constraints (also called Anchors): ^, $
- 10.6Regular Expression Quantifiers: { }
- 10.7Regular Expression Quantifiers: { }3 Days
- 10.8Bracket Expressions (Character classes): [ ]
- 10.9Escaping characters:
- 10.10Escaping characters:3 Days
- 10.11Groups(Parentheses): ( )
- 10.12Alternatives: |
- 10.13Alternatives: |3 Days
- 10.14REGEXP_COUNT
- 10.15REGEXP_INSTR
- 10.16REGEXP_LIKE
- 10.17REGEXP_REPLACE
- 10.18REGEXP_SUBSTR
- Conditional Expressions7
- GROUP BY and HAVING Clauses10
- 12.0Aggregate Functions
- 12.1Using Aggregate Functions on the entire column data set
- 12.2Using Aggregate Functions on the entire column data set3 Days
- 12.3Using Aggregate Functions with WHERE clause
- 12.4COUNT Aggregate Function
- 12.5Handling Null values in Aggregate Functions
- 12.6GROUP BY Clause
- 12.7GROUP BY Clause(Grouping by Multiple Columns)
- 12.8GROUP BY Clause3 Days
- 12.9HAVING Clause (Filter Groups using Aggregated column)
- Generating Reports with (CUBE, ROLLUP, GROUPING SET)6
- ---Day31
- JOINS9
- Window Functions (RANK, DENSE_RANK, ROW_NUMBER)9
- 16.0Windowing
- 16.1Windowing calculations(aggregate function)
- 16.2Window Functions
- 16.3Window Function OVER(ORDER BY order_list ) clause
- 16.4Window Function OVER(PARTITION BY ORDER BY ) clause
- 16.5Window Function OVER() without “window_definition”
- 16.6Window Function OVER(PARTITION BY ) clause
- 16.7WINDOW clause
- 16.8Window Functions (RANK, DENSE_RANK, ROW_NUMBER)
- Subqueries12
- 17.0SUBQUERY
- 17.1Scalar subquery
- 17.2Row subquery
- 17.3Subquery Expressions
- 17.4Multi-Row Subquery (IN, SOME/ANY, ALL)
- 17.5Multi-Row Subquery ([NOT] IN)
- 17.6Multi-Row Subquery ( ANY/SOME)
- 17.7Table subquery(Inline View)
- 17.8Multi-Row Subquery ( ALL)
- 17.9Correlated Subquery
- 17.10[NOT] EXISTS Subquery Expressions
- 17.11Subqueries3 Days
- Common Table Expressions (WITH Clause)4
- Set Operators (UNION, INTERSECT, EXCEPT)5
- ---Day41
- Data Definition (Table)18
- 21.0Data definition language (DDL)
- 21.1CREATE DATABASE
- 21.2CREATE TABLE
- 21.3CREATE TABLE with AS keyword
- 21.4ALTER TABLE (ADD Column)
- 21.5ALTER TABLE(DROP COLUMN)
- 21.6ALTER ADD (Primary key )
- 21.7ALTER TABLE(ADD foreign key)
- 21.8RENAME TABLE
- 21.9RENAME Column
- 21.10RENAME Constraint
- 21.11Comment on a TABLE
- 21.12ALTER TABLE(DROP COLUMN)
- 21.13Remove TABLE comment
- 21.14RENAME Column
- 21.15TRUNCATE
- 21.16DROP
- 21.17Data Definition(Table)3 Days
- Constraints16
- 22.0Check Constraint (column constraint, explicit constraint name )
- 22.1Check Constraint (column constraint, implicit constraint name )
- 22.2Check Constraint (table constraint, implicit constraint name )
- 22.3Check Constraint (table constraint, implicit constraint name )
- 22.4Not-Null Constraints (column constraint explicit)
- 22.5Unique Constraints (column constraint, explicit constraint name )
- 22.6Unique Constraints (column constraint, implicit constraint name )
- 22.7Unique Constraints (table constraint, explicit constraint name )
- 22.8Unique Constraints (table constraint, implicit constraint name )
- 22.9Primary Keys (column constraint, implicit constraint name )
- 22.10Primary Keys (table constraint, implicit constraint name )
- 22.11Foreign Keys (table constraint, explicit constraint name )
- 22.12Foreign Keys (table constraint, implicit constraint name )
- 22.13Default (column constraint only )
- 22.14Clean-up
- 22.15Constraints3 Days
- Data Manipulation17
- 23.0Data manipulation language (DML)
- 23.1SELECT
- 23.2INSERT
- 23.3Basic INSERT using literal, expression, and DEFAULT method1 (column name)
- 23.4Basic INSERT using literal, expression, and DEFAULT method 2(values)
- 23.5INSERT using query
- 23.6INSERT
- 23.7UPDATE
- 23.8UPDATE specific values
- 23.9UPDATE all values in column
- 23.10UPDATE multiple columns
- 23.11DELETE
- 23.12Delete specific rows
- 23.13Delete all rows
- 23.14MERGE
- 23.15Clean-up
- 23.16Data Manipulation10 Minutes0 Questions
- Transaction Control6
- ---Day51
- Data Definition (Sequences)9
- Data Definition (Views)8
Call to a member function get_id() on bool
Review
Courses you might be interested in
Description Maximise the capabilities of your database management system with the comprehensive guide, “Complete Microsoft SQL Server from Scratch”. Bootcamp. This comprehensive course is designed to equip you with the...
-
62 Leçon
Welcome to the MySQL Bootcamp! Here, you’ll learn how to become a proficient database expert and get to grips with the power of MySQL, one of the world’s most popular...
-
50 Leçon
Description The “SQL Bootcamp” The “Manipulate Data Like a Pro” course offers a structured and comprehensive educational experience, providing learners with a foundation in advanced skills for database management and...
-
24 Leçon
Description Have you always wanted a professional website for everyone? Then look no further! The ‘Master Web Hosting with Hostinger’ course will guide you through hosting your website with Hostinger....
-
11 Leçon
