LiveLessons - SQL for Any IT Professional

Files Included :

001 SQL for Any IT Professional Introduction.mp4 (35.88 MB)
MP4
001 Learning objectives.mp4 (8.74 MB)
MP4
002 1 1 Understand the Relational Database and SQL.mp4 (68.65 MB)
MP4
003 1 2 Explore the SQL language.mp4 (59.78 MB)
MP4
001 Learning objectives.mp4 (20.57 MB)
MP4
002 10 1 Select data from multiple tables.mp4 (39.26 MB)
MP4
003 10 2 Join tables in a query.mp4 (94.83 MB)
MP4
004 10 3 Bring it together with your data.mp4 (48.64 MB)
MP4
001 Learning objectives.mp4 (15.72 MB)
MP4
002 11 1 Restructure the appearance of data character functions.mp4 (126.04 MB)
MP4
003 11 2 Understand dates and times.mp4 (55.39 MB)
MP4
004 11 3 Skim the surface of aggregate functions.mp4 (13.89 MB)
MP4
001 Learning objectives.mp4 (15.61 MB)
MP4
002 12 1 Understand the need to group data.mp4 (31.4 MB)
MP4
003 12 2 Use GROUP BY in queries.mp4 (46.51 MB)
MP4
004 12 3 Place criteria on groups in queries.mp4 (35.94 MB)
MP4
005 12 4 Use HAVING in queries.mp4 (27.17 MB)
MP4
006 12 5 Group and summarize your data.mp4 (59.81 MB)
MP4
001 Learning objectives.mp4 (16.01 MB)
MP4
002 13 1 Understand subqueries.mp4 (29.39 MB)
MP4
003 13 2 Create subqueries to drill down further.mp4 (97.98 MB)
MP4
004 13 3 Explore the concept of compound queries.mp4 (24.01 MB)
MP4
005 13 4 Use compound queries to merge data sets.mp4 (33.14 MB)
MP4
001 Learning objectives.mp4 (17.95 MB)
MP4
002 14 1 Understand virtual database objects.mp4 (38.37 MB)
MP4
003 14 2 Create and drop views.mp4 (28.23 MB)
MP4
004 14 3 Update data through a view.mp4 (42.79 MB)
MP4
005 14 4 Understand performance benefits and drawbacks of views.mp4 (43.31 MB)
MP4
006 14 5 Understand and define synonyms.mp4 (17.15 MB)
MP4
007 14 6 Integrate views with any query.mp4 (55.09 MB)
MP4
001 Learning objectives.mp4 (21.94 MB)
MP4
002 15 1 Understand database administration versus schema management.mp4 (42.18 MB)
MP4
003 15 2 Use the System Catalog as a resource.mp4 (65.36 MB)
MP4
004 15 3 Manage users and privileges.mp4 (83.2 MB)
MP4
005 15 4 Use roles to control access and protect your data.mp4 (20.43 MB)
MP4
006 15 5 Manage a changing database.mp4 (74.28 MB)
MP4
001 Learning objectives.mp4 (17.32 MB)
MP4
002 16 1 Recap SQL basics.mp4 (42.94 MB)
MP4
003 16 2 Explore new data integrated into our BIRDS database.mp4 (60.65 MB)
MP4
004 16 3 Walk through SQL bonus examples.mp4 (100.54 MB)
MP4
005 16 4 Take this bonus hands-on workshop for the road.mp4 (35.86 MB)
MP4
001 Learning objectives.mp4 (12.16 MB)
MP4
002 2 1 Discover your sample database.mp4 (34.86 MB)
MP4
003 2 2 Get to know your data via manual exploration.mp4 (78.07 MB)
MP4
004 2 3 Set up your sample database.mp4 (61.6 MB)
MP4
001 Learning objectives.mp4 (9.93 MB)
MP4
002 3 1 Relate database design to SQL.mp4 (26.59 MB)
MP4
003 3 2 Understand the database life cycle.mp4 (22.47 MB)
MP4
004 3 3 Know your data.mp4 (17.28 MB)
MP4
005 3 4 Gather requirements.mp4 (20.35 MB)
MP4
006 3 5 Model your data.mp4 (55.37 MB)
MP4
001 Learning objectives.mp4 (14.91 MB)
MP4
002 4 1 Understand entities, attributes, and relationships.mp4 (61.42 MB)
MP4
003 4 2 Understand referential integrity.mp4 (23.71 MB)
MP4
004 4 3 Define entities.mp4 (15.21 MB)
MP4
005 4 4 Define attributes.mp4 (12.22 MB)
MP4
006 4 5 Define relationships.mp4 (38 MB)
MP4
007 4 6 Employ referential integrity by identifying primary and foreign keys.mp4 (45.82 MB)
MP4
008 4 7 Create an entity relationship diagram.mp4 (65.25 MB)
MP4
001 Learning objectives.mp4 (9.55 MB)
MP4
002 5 1 Understand normalization.mp4 (33.6 MB)
MP4
003 5 2 Explore the most common normal forms.mp4 (74.28 MB)
MP4
004 5 3 Apply normalization to your database.mp4 (31.95 MB)
MP4
001 Learning objectives.mp4 (8.38 MB)
MP4
002 6 1 Review your data to this point.mp4 (25.2 MB)
MP4
003 6 2 Explore various datatypes in SQL.mp4 (68.73 MB)
MP4
004 6 3 Fully define your data.mp4 (30.06 MB)
MP4
001 Learning objectives.mp4 (19.75 MB)
MP4
002 7 1 Review of the logical database design.mp4 (39.6 MB)
MP4
003 7 2 Create and manage tables based on your design.mp4 (63.76 MB)
MP4
004 7 3 Enforce database rules with constraints.mp4 (61.66 MB)
MP4
005 7 4 Define other common database objects.mp4 (62.43 MB)
MP4
001 Learning objectives.mp4 (15.78 MB)
MP4
002 8 1 Populate tables with data.mp4 (27.75 MB)
MP4
003 8 2 Update existing data.mp4 (36.13 MB)
MP4
004 8 3 Delete data.mp4 (31.03 MB)
MP4
005 8 4 Manage transactions.mp4 (51.69 MB)
MP4
006 8 5 Create database objects from other objects.mp4 (33.61 MB)
MP4
001 Learning objectives.mp4 (20.71 MB)
MP4
002 9 1 Query your database without SQL.mp4 (54.11 MB)
MP4
003 9 2 Explore the fundamentals of a SQL Query.mp4 (84.64 MB)
MP4
004 9 3 Use operators in queries.mp4 (61.39 MB)
MP4
001 SQL for Any IT Professional Summary.mp4 (47.97 MB)
MP4